Week 1 - Preprocessed data

Dataset statistics

Number of variables	35
Number of observations	9694
Missing cells	27630
Missing cells (%)	8.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	2.2 MiB
Average record size in memory	238.0 B

Variable types

Numeric	14
Categorical	14
Boolean	7

Alerts

`insulin` is highly correlated with `diabetesMed`	High correlation
`change` is highly correlated with `diabetesMed`	High correlation
`diabetesMed` is highly correlated with `insulin` and 1 other fields	High correlation
`insulin` is highly correlated with `diabetesMed`	High correlation
`change` is highly correlated with `diabetesMed`	High correlation
`diabetesMed` is highly correlated with `insulin` and 1 other fields	High correlation
`insulin` is highly correlated with `diabetesMed`	High correlation
`change` is highly correlated with `diabetesMed`	High correlation
`diabetesMed` is highly correlated with `insulin` and 1 other fields	High correlation
`insulin` is highly correlated with `diabetesMed`	High correlation
`diabetesMed` is highly correlated with `insulin` and 1 other fields	High correlation
`change` is highly correlated with `diabetesMed`	High correlation
`admission_source_code` is highly correlated with `admission_type_code`	High correlation
`admission_type_code` is highly correlated with `admission_source_code`	High correlation
`gender` is highly correlated with `hemoglobin_level`	High correlation
`age` is highly correlated with `medical_specialty`	High correlation
`admission_type_code` is highly correlated with `admission_source_code` and 1 other fields	High correlation
`admission_source_code` is highly correlated with `admission_type_code`	High correlation
`medical_specialty` is highly correlated with `age` and 2 other fields	High correlation
`diag_1` is highly correlated with `medical_specialty` and 2 other fields	High correlation
`diag_2` is highly correlated with `diag_1` and 1 other fields	High correlation
`diag_3` is highly correlated with `diag_1` and 2 other fields	High correlation
`number_diagnoses` is highly correlated with `diag_3`	High correlation
`hemoglobin_level` is highly correlated with `gender`	High correlation
`insulin` is highly correlated with `change` and 1 other fields	High correlation
`change` is highly correlated with `insulin` and 1 other fields	High correlation
`diabetesMed` is highly correlated with `insulin` and 1 other fields	High correlation
`age` has 293 (3.0%) missing values	Missing
`weight` has 9389 (96.9%) missing values	Missing
`num_lab_procedures` has 184 (1.9%) missing values	Missing
`num_medications` has 308 (3.2%) missing values	Missing
`max_glu_serum` has 9186 (94.8%) missing values	Missing
`A1Cresult` has 8070 (83.2%) missing values	Missing
`readmitted` has 200 (2.1%) missing values	Missing
`number_emergency` is highly skewed (γ1 = 32.69060597)	Skewed
`Unnamed: 0` is uniformly distributed	Uniform
`Unnamed: 0` has unique values	Unique
`admission_id` has unique values	Unique
`num_procedures` has 4385 (45.2%) zeros	Zeros
`number_outpatient` has 8093 (83.5%) zeros	Zeros
`number_emergency` has 8613 (88.8%) zeros	Zeros
`number_inpatient` has 6490 (66.9%) zeros	Zeros

Reproduction

Analysis started	2022-03-04 16:47:09.902006
Analysis finished	2022-03-04 16:47:49.112894
Duration	39.21 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

Unnamed: 0
Real number (ℝ_≥0)

UNIFORM
UNIQUE

Distinct	9694
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4846.5

Minimum	0
Maximum	9693
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	75.9 KiB

Quantile statistics

Minimum	0
5-th percentile	484.65
Q1	2423.25
median	4846.5
Q3	7269.75
95-th percentile	9208.35
Maximum	9693
Range	9693
Interquartile range (IQR)	4846.5

Descriptive statistics

Standard deviation	2798.561089
Coefficient of variation (CV)	0.5774396139
Kurtosis	-1.2
Mean	4846.5
Median Absolute Deviation (MAD)	2423.5
Skewness	0
Sum	46981971
Variance	7831944.167
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
4735	1	< 0.1%
2692	1	< 0.1%
645	1	< 0.1%
6790	1	< 0.1%
4743	1	< 0.1%
8841	1	< 0.1%
2700	1	< 0.1%
653	1	< 0.1%
6798	1	< 0.1%
Other values (9684)	9684	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
9693	1	< 0.1%
9692	1	< 0.1%
9691	1	< 0.1%
9690	1	< 0.1%
9689	1	< 0.1%
9688	1	< 0.1%
9687	1	< 0.1%
9686	1	< 0.1%
9685	1	< 0.1%
9684	1	< 0.1%

admission_id
Real number (ℝ_≥0)

UNIQUE

Distinct	9694
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	91396.53858

Minimum	81412
Maximum	101440
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	75.9 KiB

Quantile statistics

Minimum	81412
5-th percentile	82456.95
Q1	86442.25
median	91364
Q3	96385.25
95-th percentile	100380.35
Maximum	101440
Range	20028
Interquartile range (IQR)	9943

Descriptive statistics

Standard deviation	5745.128963
Coefficient of variation (CV)	0.0628593714
Kurtosis	-1.193941082
Mean	91396.53858
Median Absolute Deviation (MAD)	4974
Skewness	0.003909738519
Sum	885998045
Variance	33006506.8
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
92771	1	< 0.1%
101435	1	< 0.1%
89033	1	< 0.1%
86885	1	< 0.1%
98093	1	< 0.1%
89183	1	< 0.1%
81667	1	< 0.1%
89282	1	< 0.1%
88076	1	< 0.1%
83824	1	< 0.1%
Other values (9684)	9684	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
81412	1	< 0.1%
81415	1	< 0.1%
81417	1	< 0.1%
81418	1	< 0.1%
81419	1	< 0.1%
81420	1	< 0.1%
81426	1	< 0.1%
81427	1	< 0.1%
81429	1	< 0.1%
81431	1	< 0.1%

Value	Count	Frequency (%)
101440	1	< 0.1%
101438	1	< 0.1%
101437	1	< 0.1%
101435	1	< 0.1%
101432	1	< 0.1%
101430	1	< 0.1%
101429	1	< 0.1%
101422	1	< 0.1%
101416	1	< 0.1%
101415	1	< 0.1%

patient_id
Real number (ℝ_≥0)

Distinct	9219
Distinct (%)	95.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	108440221.2

Minimum	10368
Maximum	378731656
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	75.9 KiB

Quantile statistics

Minimum	10368
5-th percentile	2786253.3
Q1	46740537
median	91137042
Q3	175249750.5
95-th percentile	222658891.2
Maximum	378731656
Range	378721288
Interquartile range (IQR)	128509213.5

Descriptive statistics

Standard deviation	77557704.94
Coefficient of variation (CV)	0.7152116076
Kurtosis	-0.3056385962
Mean	108440221.2
Median Absolute Deviation (MAD)	66517875
Skewness	0.4817043225
Sum	1.051219505 × 10¹²
Variance	6.015197596 × 10¹⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
86281740	6	0.1%
3061368	5	0.1%
769806	5	0.1%
85026852	4	< 0.1%
74193660	4	< 0.1%
46796904	4	< 0.1%
177579342	4	< 0.1%
186411312	3	< 0.1%
184554756	3	< 0.1%
99440244	3	< 0.1%
Other values (9209)	9653	99.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
10368	1	< 0.1%
13320	1	< 0.1%
13374	1	< 0.1%
16344	1	< 0.1%
22950	1	< 0.1%
24822	1	< 0.1%
26010	1	< 0.1%
29520	1	< 0.1%
37458	1	< 0.1%
44244	1	< 0.1%

Value	Count	Frequency (%)
378731656	1	< 0.1%
378515620	1	< 0.1%
378390772	1	< 0.1%
378338950	1	< 0.1%
377407324	1	< 0.1%
376569694	1	< 0.1%
376238278	1	< 0.1%
375847048	1	< 0.1%
373535938	1	< 0.1%
373514608	1	< 0.1%

race
Categorical

Distinct	6
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	75.9 KiB

white	7244
black	1798
unknown	227
hispanic	197
other	168

Length

Max length	8
Median length	5
Mean length	5.107798638
Min length	5

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	white
2nd row	black
3rd row	black
4th row	white
5th row	hispanic

Common Values

Value	Count	Frequency (%)
white	7244	74.7%
black	1798	18.5%
unknown	227	2.3%
hispanic	197	2.0%
other	168	1.7%
asian	60	0.6%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
white	7244	74.7%
black	1798	18.5%
unknown	227	2.3%
hispanic	197	2.0%
other	168	1.7%
asian	60	0.6%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

gender
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	75.9 KiB

female	5239
male	4454
unknown	1

Length

Max length	7
Median length	6
Mean length	5.081184238
Min length	4

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	male
2nd row	male
3rd row	female
4th row	male
5th row	male

Common Values

Value	Count	Frequency (%)
female	5239	54.0%
male	4454	45.9%
unknown	1	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
female	5239	54.0%
male	4454	45.9%
unknown	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

age
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	10
Distinct (%)	0.1%
Missing	293
Missing (%)	3.0%
Infinite	0
Infinite (%)	0.0%
Mean	60.86161047

Minimum	0
Maximum	90
Zeros	10
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	75.9 KiB

Quantile statistics

Minimum	0
5-th percentile	30
Q1	50
median	60
Q3	70
95-th percentile	80
Maximum	90
Range	90
Interquartile range (IQR)	20

Descriptive statistics

Standard deviation	15.67428086
Coefficient of variation (CV)	0.2575396993
Kurtosis	0.241595252
Mean	60.86161047
Median Absolute Deviation (MAD)	10
Skewness	-0.6052773068
Sum	572160
Variance	245.6830803
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
70	2471	25.5%
60	2113	21.8%
50	1606	16.6%
80	1498	15.5%
40	914	9.4%
30	336	3.5%
90	245	2.5%
20	150	1.5%
10	58	0.6%
0	10	0.1%
(Missing)	293	3.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	10	0.1%
10	58	0.6%
20	150	1.5%
30	336	3.5%
40	914	9.4%
50	1606	16.6%
60	2113	21.8%
70	2471	25.5%
80	1498	15.5%
90	245	2.5%

Value	Count	Frequency (%)
90	245	2.5%
80	1498	15.5%
70	2471	25.5%
60	2113	21.8%
50	1606	16.6%
40	914	9.4%
30	336	3.5%
20	150	1.5%
10	58	0.6%
0	10	0.1%

weight
Real number (ℝ_≥0)

MISSING

Distinct	8
Distinct (%)	2.6%
Missing	9389
Missing (%)	96.9%
Infinite	0
Infinite (%)	0.0%
Mean	76.06557377

Minimum	0
Maximum	175
Zeros	2
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	75.9 KiB

Quantile statistics

Minimum	0
5-th percentile	50
Q1	50
median	75
Q3	100
95-th percentile	125
Maximum	175
Range	175
Interquartile range (IQR)	50

Descriptive statistics

Standard deviation	25.34490298
Coefficient of variation (CV)	0.3331980779
Kurtosis	0.9805279891
Mean	76.06557377
Median Absolute Deviation (MAD)	25
Skewness	0.3528171881
Sum	23200
Variance	642.364107
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
75	130	1.3%
50	75	0.8%
100	68	0.7%
125	15	0.2%
25	10	0.1%
150	4	< 0.1%
0	2	< 0.1%
175	1	< 0.1%
(Missing)	9389	96.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2	< 0.1%
25	10	0.1%
50	75	0.8%
75	130	1.3%
100	68	0.7%
125	15	0.2%
150	4	< 0.1%
175	1	< 0.1%

Value	Count	Frequency (%)
175	1	< 0.1%
150	4	< 0.1%
125	15	0.2%
100	68	0.7%
75	130	1.3%
50	75	0.8%
25	10	0.1%
0	2	< 0.1%

admission_type_code
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	5
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	75.9 KiB

Emergency	5003
Elective	1811
Urgent	1759
unknown	1119
Trauma Center	2

Length

Max length	13
Median length	9
Mean length	8.038786878
Min length	6

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Urgent
2nd row	Urgent
3rd row	Elective
4th row	Elective
5th row	Emergency

Common Values

Value	Count	Frequency (%)
Emergency	5003	51.6%
Elective	1811	18.7%
Urgent	1759	18.1%
unknown	1119	11.5%
Trauma Center	2	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
emergency	5003	51.6%
elective	1811	18.7%
urgent	1759	18.1%
unknown	1119	11.5%
trauma	2	< 0.1%
center	2	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

discharge_disposition_code
Categorical

Distinct	20
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	75.9 KiB

Discharged to home	5786
Discharged/transferred to SNF	1342
Discharged/transferred to home with home health service	1244
unknown	545
Discharged/transferred to another short term hospital	202
Other values (15)	575

Length

Max length	105
Median length	18
Mean length	26.53775531
Min length	7

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5 ?
Unique (%)	0.1%

Sample

1st row	Discharged to home
2nd row	unknown
3rd row	Discharged to home
4th row	Discharged to home
5th row	Discharged/transferred to SNF

Common Values

Value	Count	Frequency (%)
Discharged to home	5786	59.7%
Discharged/transferred to SNF	1342	13.8%
Discharged/transferred to home with home health service	1244	12.8%
unknown	545	5.6%
Discharged/transferred to another short term hospital	202	2.1%
Discharged/transferred to another rehab fac including rehab units of a hospital	181	1.9%
Discharged/transferred to another type of inpatient care institution	118	1.2%
Discharged/transferred to ICF	70	0.7%
Left AMA	55	0.6%
Discharged/transferred to a long term care hospital	50	0.5%
Other values (10)	101	1.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
to	9024	25.1%
home	8332	23.1%
discharged	5786	16.1%
discharged/transferred	3223	8.9%
snf	1342	3.7%
health	1245	3.5%
with	1244	3.5%
service	1244	3.5%
unknown	545	1.5%
another	502	1.4%
Other values (47)	3534	9.8%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

admission_source_code
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	10
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	75.9 KiB

Emergency Room	5468
Physician Referral	2841
unknown	679
Transfer from a hospital	302
Transfer from another health care facility	192
Other values (5)	212

Length

Max length	46
Median length	14
Mean length	15.812255
Min length	7

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Physician Referral
2nd row	Clinic Referral
3rd row	Physician Referral
4th row	Physician Referral
5th row	Emergency Room

Common Values

Value	Count	Frequency (%)
Emergency Room	5468	56.4%
Physician Referral	2841	29.3%
unknown	679	7.0%
Transfer from a hospital	302	3.1%
Transfer from another health care facility	192	2.0%
Clinic Referral	114	1.2%
Transfer from a Skilled Nursing Facility (SNF)	76	0.8%
HMO Referral	19	0.2%
Transfer from critial access hospital	2	< 0.1%
Court/Law Enforcement	1	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
emergency	5468	26.7%
room	5468	26.7%
referral	2974	14.5%
physician	2841	13.9%
unknown	679	3.3%
transfer	572	2.8%
from	572	2.8%
a	378	1.8%
hospital	304	1.5%
facility	268	1.3%
Other values (12)	943	4.6%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

time_in_hospital
Real number (ℝ_≥0)

Distinct	14
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.389725603

Minimum	1
Maximum	14
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	75.9 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	4
Q3	6
95-th percentile	11
Maximum	14
Range	13
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	3.004512179
Coefficient of variation (CV)	0.6844419107
Kurtosis	0.8095413805
Mean	4.389725603
Median Absolute Deviation (MAD)	2
Skewness	1.130620534
Sum	42554
Variance	9.027093435
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
3	1692	17.5%
2	1656	17.1%
1	1388	14.3%
4	1275	13.2%
5	945	9.7%
6	720	7.4%
7	544	5.6%
8	421	4.3%
9	293	3.0%
10	214	2.2%
Other values (4)	546	5.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1388	14.3%
2	1656	17.1%
3	1692	17.5%
4	1275	13.2%
5	945	9.7%
6	720	7.4%
7	544	5.6%
8	421	4.3%
9	293	3.0%
10	214	2.2%

Value	Count	Frequency (%)
14	93	1.0%
13	128	1.3%
12	139	1.4%
11	186	1.9%
10	214	2.2%
9	293	3.0%
8	421	4.3%
7	544	5.6%
6	720	7.4%
5	945	9.7%

payer_code
Categorical

Distinct	17
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	75.9 KiB

unknown	3843
MC	3038
HM	617
SP	491
BC	453
Other values (12)	1252

Length

Max length	7
Median length	2
Mean length	3.98215391
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	BC
2nd row	unknown
3rd row	BC
4th row	MC
5th row	unknown

Common Values

Value	Count	Frequency (%)
unknown	3843	39.6%
MC	3038	31.3%
HM	617	6.4%
SP	491	5.1%
BC	453	4.7%
MD	332	3.4%
UN	244	2.5%
CP	213	2.2%
CM	195	2.0%
OG	120	1.2%
Other values (7)	148	1.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
unknown	3843	39.6%
mc	3038	31.3%
hm	617	6.4%
sp	491	5.1%
bc	453	4.7%
md	332	3.4%
un	244	2.5%
cp	213	2.2%
cm	195	2.0%
og	120	1.2%
Other values (7)	148	1.5%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

medical_specialty
Categorical

HIGH CORRELATION

Distinct	24
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	75.9 KiB

Others	4729
InternalMedicine	1355
Emergency/Trauma	759
Family/GeneralPractice	738
Cardiology	507
Other values (19)	1606

Length

Max length	22
Median length	7
Mean length	10.25562203
Min length	6

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Endocrinology
2nd row	Others
3rd row	Family/GeneralPractice
4th row	Radiology
5th row	Others

Common Values

Value	Count	Frequency (%)
Others	4729	48.8%
InternalMedicine	1355	14.0%
Emergency/Trauma	759	7.8%
Family/GeneralPractice	738	7.6%
Cardiology	507	5.2%
Surgery	502	5.2%
Orthopedics	271	2.8%
Radiology	133	1.4%
Nephrology	122	1.3%
Psychiatry	104	1.1%
Other values (14)	474	4.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
others	4729	48.8%
internalmedicine	1355	14.0%
emergency/trauma	759	7.8%
family/generalpractice	738	7.6%
cardiology	507	5.2%
surgery	502	5.2%
orthopedics	271	2.8%
radiology	133	1.4%
nephrology	122	1.3%
psychiatry	104	1.1%
Other values (14)	474	4.9%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

has_prosthesis
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.6 KiB

False	9599
True	95

Common Values
Chart

Value	Count	Frequency (%)
False	9599	99.0%
True	95	1.0%

complete_vaccination_status
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	75.9 KiB

complete	8106
incomplete	1550
none	38

Length

Max length	10
Median length	8
Mean length	8.304105632
Min length	4

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	complete
2nd row	complete
3rd row	complete
4th row	complete
5th row	complete

Common Values

Value	Count	Frequency (%)
complete	8106	83.6%
incomplete	1550	16.0%
none	38	0.4%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
complete	8106	83.6%
incomplete	1550	16.0%
none	38	0.4%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

num_lab_procedures
Real number (ℝ_≥0)

MISSING

Distinct	105
Distinct (%)	1.1%
Missing	184
Missing (%)	1.9%
Infinite	0
Infinite (%)	0.0%
Mean	42.94090431

Minimum	1
Maximum	111
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	75.9 KiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	31
median	44
Q3	57
95-th percentile	73
Maximum	111
Range	110
Interquartile range (IQR)	26

Descriptive statistics

Standard deviation	19.86203542
Coefficient of variation (CV)	0.4625434824
Kurtosis	-0.2834919112
Mean	42.94090431
Median Absolute Deviation (MAD)	13
Skewness	-0.2405578687
Sum	408368
Variance	394.500451
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	320	3.3%
43	255	2.6%
42	219	2.3%
49	218	2.2%
45	217	2.2%
44	216	2.2%
39	206	2.1%
40	206	2.1%
46	203	2.1%
37	198	2.0%
Other values (95)	7252	74.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	320	3.3%
2	109	1.1%
3	56	0.6%
4	37	0.4%
5	31	0.3%
6	34	0.4%
7	24	0.2%
8	43	0.4%
9	85	0.9%
10	92	0.9%

Value	Count	Frequency (%)
111	1	< 0.1%
109	1	< 0.1%
107	1	< 0.1%
103	1	< 0.1%
102	1	< 0.1%
101	2	< 0.1%
100	3	< 0.1%
98	1	< 0.1%
97	4	< 0.1%
96	1	< 0.1%

num_procedures
Real number (ℝ_≥0)

ZEROS

Distinct	7
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.349391376

Minimum	0
Maximum	6
Zeros	4385
Zeros (%)	45.2%
Negative	0
Negative (%)	0.0%
Memory size	75.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	2
95-th percentile	5
Maximum	6
Range	6
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.703723337
Coefficient of variation (CV)	1.262586502
Kurtosis	0.836890554
Mean	1.349391376
Median Absolute Deviation (MAD)	1
Skewness	1.307333976
Sum	13081
Variance	2.902673208
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
0	4385	45.2%
1	2007	20.7%
2	1234	12.7%
3	914	9.4%
6	461	4.8%
4	367	3.8%
5	326	3.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4385	45.2%
1	2007	20.7%
2	1234	12.7%
3	914	9.4%
4	367	3.8%
5	326	3.4%
6	461	4.8%

Value	Count	Frequency (%)
6	461	4.8%
5	326	3.4%
4	367	3.8%
3	914	9.4%
2	1234	12.7%
1	2007	20.7%
0	4385	45.2%

num_medications
Real number (ℝ_≥0)

MISSING

Distinct	64
Distinct (%)	0.7%
Missing	308
Missing (%)	3.2%
Infinite	0
Infinite (%)	0.0%
Mean	16.0644577

Minimum	1
Maximum	79
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	75.9 KiB

Quantile statistics

Minimum	1
5-th percentile	6
Q1	10
median	15
Q3	20
95-th percentile	31
Maximum	79
Range	78
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	8.277705312
Coefficient of variation (CV)	0.5152807188
Kurtosis	3.558316821
Mean	16.0644577
Median Absolute Deviation (MAD)	5
Skewness	1.382377006
Sum	150781
Variance	68.52040523
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
15	568	5.9%
13	566	5.8%
12	557	5.7%
11	551	5.7%
10	510	5.3%
14	502	5.2%
16	482	5.0%
9	445	4.6%
17	445	4.6%
18	406	4.2%
Other values (54)	4354	44.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	26	0.3%
2	51	0.5%
3	83	0.9%
4	109	1.1%
5	174	1.8%
6	242	2.5%
7	355	3.7%
8	406	4.2%
9	445	4.6%
10	510	5.3%

Value	Count	Frequency (%)
79	1	< 0.1%
66	1	< 0.1%
65	1	< 0.1%
61	4	< 0.1%
60	3	< 0.1%
59	3	< 0.1%
58	6	0.1%
57	3	< 0.1%
56	4	< 0.1%
55	3	< 0.1%

number_outpatient
Real number (ℝ_≥0)

ZEROS

Distinct	19
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.3634206726

Minimum	0
Maximum	21
Zeros	8093
Zeros (%)	83.5%
Negative	0
Negative (%)	0.0%
Memory size	75.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	2
Maximum	21
Range	21
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.187414181
Coefficient of variation (CV)	3.267327014
Kurtosis	70.18884936
Mean	0.3634206726
Median Absolute Deviation (MAD)	0
Skewness	6.716536954
Sum	3523
Variance	1.409952437
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=19)

Value	Count	Frequency (%)
0	8093	83.5%
1	824	8.5%
2	330	3.4%
3	212	2.2%
4	106	1.1%
5	49	0.5%
6	30	0.3%
8	11	0.1%
7	8	0.1%
11	5	0.1%
Other values (9)	26	0.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	8093	83.5%
1	824	8.5%
2	330	3.4%
3	212	2.2%
4	106	1.1%
5	49	0.5%
6	30	0.3%
7	8	0.1%
8	11	0.1%
9	5	0.1%

Value	Count	Frequency (%)
21	2	< 0.1%
19	1	< 0.1%
17	3	< 0.1%
16	1	< 0.1%
15	4	< 0.1%
14	4	< 0.1%
13	2	< 0.1%
11	5	0.1%
10	4	< 0.1%
9	5	0.1%

number_emergency
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct	15
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.1893955024

Minimum	0
Maximum	63
Zeros	8613
Zeros (%)	88.8%
Negative	0
Negative (%)	0.0%
Memory size	75.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	63
Range	63
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.952079387
Coefficient of variation (CV)	5.026937678
Kurtosis	1978.568005
Mean	0.1893955024
Median Absolute Deviation (MAD)	0
Skewness	32.69060597
Sum	1836
Variance	0.9064551592
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=15)

Value	Count	Frequency (%)
0	8613	88.8%
1	747	7.7%
2	195	2.0%
3	57	0.6%
4	42	0.4%
5	8	0.1%
7	8	0.1%
8	6	0.1%
6	6	0.1%
10	4	< 0.1%
Other values (5)	8	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	8613	88.8%
1	747	7.7%
2	195	2.0%
3	57	0.6%
4	42	0.4%
5	8	0.1%
6	6	0.1%
7	8	0.1%
8	6	0.1%
9	2	< 0.1%

Value	Count	Frequency (%)
63	1	< 0.1%
13	1	< 0.1%
12	2	< 0.1%
11	2	< 0.1%
10	4	< 0.1%
9	2	< 0.1%
8	6	0.1%
7	8	0.1%
6	6	0.1%
5	8	0.1%

number_inpatient
Real number (ℝ_≥0)

ZEROS

Distinct	17
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.6262636682

Minimum	0
Maximum	16
Zeros	6490
Zeros (%)	66.9%
Negative	0
Negative (%)	0.0%
Memory size	75.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	3
Maximum	16
Range	16
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.254516375
Coefficient of variation (CV)	2.00317604
Kurtosis	21.20301943
Mean	0.6262636682
Median Absolute Deviation (MAD)	0
Skewness	3.647348129
Sum	6071
Variance	1.573811335
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
0	6490	66.9%
1	1837	18.9%
2	694	7.2%
3	326	3.4%
4	156	1.6%
5	85	0.9%
6	47	0.5%
8	17	0.2%
7	16	0.2%
10	8	0.1%
Other values (7)	18	0.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	6490	66.9%
1	1837	18.9%
2	694	7.2%
3	326	3.4%
4	156	1.6%
5	85	0.9%
6	47	0.5%
7	16	0.2%
8	17	0.2%
9	6	0.1%

Value	Count	Frequency (%)
16	1	< 0.1%
15	2	< 0.1%
14	2	< 0.1%
13	1	< 0.1%
12	2	< 0.1%
11	4	< 0.1%
10	8	0.1%
9	6	0.1%
8	17	0.2%
7	16	0.2%

diag_1
Categorical

HIGH CORRELATION

Distinct	18
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	75.9 KiB

diseases of the circulatory system	2954
endocrine, nutritional and metabolic diseases, and immunity disorders	1054
diseases of the respiratory system	953
diseases of the digestive system	864
symptoms, signs, and ill-defined conditions	708
Other values (13)	3161

Length

Max length	69
Median length	34
Mean length	37.9945327
Min length	7

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	diseases of the digestive system
2nd row	diseases of the circulatory system
3rd row	diseases of the digestive system
4th row	diseases of the circulatory system
5th row	injury and poisoning

Common Values

Value	Count	Frequency (%)
diseases of the circulatory system	2954	30.5%
endocrine, nutritional and metabolic diseases, and immunity disorders	1054	10.9%
diseases of the respiratory system	953	9.8%
diseases of the digestive system	864	8.9%
symptoms, signs, and ill-defined conditions	708	7.3%
injury and poisoning	648	6.7%
diseases of the genitourinary system	500	5.2%
diseases of the musculoskeletal system and connective tissue	489	5.0%
neoplasms	333	3.4%
infectious and parasitic diseases	264	2.7%
Other values (8)	927	9.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
diseases	7563	15.0%
of	6464	12.8%
the	6297	12.5%
system	5878	11.6%
and	4754	9.4%
circulatory	2954	5.8%
disorders	1272	2.5%
nutritional	1054	2.1%
metabolic	1054	2.1%
immunity	1054	2.1%
Other values (33)	12216	24.2%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

diag_2
Categorical

HIGH CORRELATION

Distinct	18
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	75.9 KiB

diseases of the circulatory system	2960
endocrine, nutritional and metabolic diseases, and immunity disorders	1991
diseases of the respiratory system	919
diseases of the genitourinary system	754
symptoms, signs, and ill-defined conditions	434
Other values (13)	2636

Length

Max length	69
Median length	34
Mean length	40.73179286
Min length	7

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	endocrine, nutritional and metabolic diseases, and immunity disorders
2nd row	diseases of the genitourinary system
3rd row	diseases of the genitourinary system
4th row	diseases of the circulatory system
5th row	injury and poisoning

Common Values

Value	Count	Frequency (%)
diseases of the circulatory system	2960	30.5%
endocrine, nutritional and metabolic diseases, and immunity disorders	1991	20.5%
diseases of the respiratory system	919	9.5%
diseases of the genitourinary system	754	7.8%
symptoms, signs, and ill-defined conditions	434	4.5%
diseases of the digestive system	369	3.8%
diseases of the skin and subcutaneous tissue	323	3.3%
mental disorders	282	2.9%
diseases of the blood and blood-forming organs	265	2.7%
external causes of injury	238	2.5%
Other values (8)	1159	12.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
diseases	8034	15.1%
of	6142	11.6%
the	5904	11.1%
and	5718	10.8%
system	5284	10.0%
circulatory	2960	5.6%
disorders	2273	4.3%
endocrine	1991	3.8%
nutritional	1991	3.8%
metabolic	1991	3.8%
Other values (33)	10753	20.3%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

diag_3
Categorical

HIGH CORRELATION

Distinct	18
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	75.9 KiB

diseases of the circulatory system	2893
endocrine, nutritional and metabolic diseases, and immunity disorders	2587
diseases of the respiratory system	584
diseases of the genitourinary system	574
external causes of injury	496
Other values (13)	2560

Length

Max length	69
Median length	34
Mean length	42.90406437
Min length	7

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	diseases of the circulatory system
2nd row	diseases of the respiratory system
3rd row	diseases of the genitourinary system
4th row	mental disorders
5th row	injury and poisoning

Common Values

Value	Count	Frequency (%)
diseases of the circulatory system	2893	29.8%
endocrine, nutritional and metabolic diseases, and immunity disorders	2587	26.7%
diseases of the respiratory system	584	6.0%
diseases of the genitourinary system	574	5.9%
external causes of injury	496	5.1%
symptoms, signs, and ill-defined conditions	403	4.2%
diseases of the digestive system	317	3.3%
mental disorders	303	3.1%
diseases of the blood and blood-forming organs	242	2.5%
diseases of the skin and subcutaneous tissue	210	2.2%
Other values (8)	1085	11.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
diseases	7942	14.4%
and	6786	12.3%
of	5708	10.4%
the	5212	9.5%
system	4733	8.6%
circulatory	2893	5.3%
disorders	2890	5.3%
endocrine	2587	4.7%
nutritional	2587	4.7%
metabolic	2587	4.7%
Other values (33)	11088	20.2%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

number_diagnoses
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	14
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.41252321

Minimum	1
Maximum	16
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	75.9 KiB

Quantile statistics

Minimum	1
5-th percentile	4
Q1	6
median	8
Q3	9
95-th percentile	9
Maximum	16
Range	15
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.954272453
Coefficient of variation (CV)	0.2636446993
Kurtosis	-0.1242502461
Mean	7.41252321
Median Absolute Deviation (MAD)	1
Skewness	-0.9111943497
Sum	71857
Variance	3.819180819
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
9	4746	49.0%
5	1038	10.7%
8	1013	10.4%
6	984	10.2%
7	935	9.6%
4	542	5.6%
3	298	3.1%
2	109	1.1%
1	22	0.2%
16	2	< 0.1%
Other values (4)	5	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	22	0.2%
2	109	1.1%
3	298	3.1%
4	542	5.6%
5	1038	10.7%
6	984	10.2%
7	935	9.6%
8	1013	10.4%
9	4746	49.0%
10	1	< 0.1%

Value	Count	Frequency (%)
16	2	< 0.1%
15	2	< 0.1%
14	1	< 0.1%
12	1	< 0.1%
10	1	< 0.1%
9	4746	49.0%
8	1013	10.4%
7	935	9.6%
6	984	10.2%
5	1038	10.7%

blood_type
Categorical

Distinct	8
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	75.9 KiB

O+	3799
A+	2968
B+	1074
O-	702
A-	578
Other values (3)	573

Length

Max length	3
Median length	2
Mean length	2.042603672
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	A+
2nd row	O-
3rd row	A+
4th row	O-
5th row	O+

Common Values

Value	Count	Frequency (%)
O+	3799	39.2%
A+	2968	30.6%
B+	1074	11.1%
O-	702	7.2%
A-	578	6.0%
AB+	321	3.3%
B-	160	1.7%
AB-	92	0.9%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
o	4501	46.4%
a	3546	36.6%
b	1234	12.7%
ab	413	4.3%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

hemoglobin_level
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	70
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14.18680627

Minimum	10.9
Maximum	18
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	75.9 KiB

Quantile statistics

Minimum	10.9
5-th percentile	12.6
Q1	13.4
median	14.1
Q3	14.9
95-th percentile	16
Maximum	18
Range	7.1
Interquartile range (IQR)	1.5

Descriptive statistics

Standard deviation	1.050907971
Coefficient of variation (CV)	0.07407643069
Kurtosis	-0.4462990845
Mean	14.18680627
Median Absolute Deviation (MAD)	0.8
Skewness	0.189357108
Sum	137526.9
Variance	1.104407564
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13.6	354	3.7%
13.8	348	3.6%
13.5	337	3.5%
14.5	326	3.4%
13.7	323	3.3%
13.4	318	3.3%
13.9	316	3.3%
14	315	3.2%
14.4	313	3.2%
14.3	313	3.2%
Other values (60)	6431	66.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
10.9	1	< 0.1%
11.1	1	< 0.1%
11.2	2	< 0.1%
11.3	3	< 0.1%
11.4	2	< 0.1%
11.5	2	< 0.1%
11.6	7	0.1%
11.7	11	0.1%
11.8	13	0.1%
11.9	22	0.2%

Value	Count	Frequency (%)
18	1	< 0.1%
17.8	1	< 0.1%
17.7	2	< 0.1%
17.6	1	< 0.1%
17.5	2	< 0.1%
17.4	3	< 0.1%
17.3	1	< 0.1%
17.2	1	< 0.1%
17.1	8	0.1%
17	8	0.1%

blood_transfusion
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.6 KiB

False	8522
True	1172

Common Values
Chart

Value	Count	Frequency (%)
False	8522	87.9%
True	1172	12.1%

max_glu_serum
Categorical

MISSING

Distinct	3
Distinct (%)	0.6%
Missing	9186
Missing (%)	94.8%
Memory size	75.9 KiB

85.0	260
200.0	147
300.0	101

Length

Max length	5
Median length	4
Mean length	4.488188976
Min length	4

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	85.0
2nd row	85.0
3rd row	200.0
4th row	300.0
5th row	200.0

Common Values

Value	Count	Frequency (%)
85.0	260	2.7%
200.0	147	1.5%
300.0	101	1.0%
(Missing)	9186	94.8%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
85.0	260	51.2%
200.0	147	28.9%
300.0	101	19.9%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

A1Cresult
Categorical

MISSING

Distinct	3
Distinct (%)	0.2%
Missing	8070
Missing (%)	83.2%
Memory size	75.9 KiB

8.0	798
5.0	478
7.0	348

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	8.0
2nd row	7.0
3rd row	5.0
4th row	7.0
5th row	8.0

Common Values

Value	Count	Frequency (%)
8.0	798	8.2%
5.0	478	4.9%
7.0	348	3.6%
(Missing)	8070	83.2%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
8.0	798	49.1%
5.0	478	29.4%
7.0	348	21.4%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

diuretics
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.6 KiB

False	9515
True	179

Common Values
Chart

Value	Count	Frequency (%)
False	9515	98.2%
True	179	1.8%

insulin
Boolean

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.6 KiB

True	5257
False	4437

Common Values
Chart

Value	Count	Frequency (%)
True	5257	54.2%
False	4437	45.8%

change
Boolean

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.6 KiB

False	5165
True	4529

Common Values
Chart

Value	Count	Frequency (%)
False	5165	53.3%
True	4529	46.7%

diabetesMed
Boolean

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.6 KiB

True	7493
False	2201

Common Values
Chart

Value	Count	Frequency (%)
True	7493	77.3%
False	2201	22.7%

readmitted
Boolean

MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	200
Missing (%)	2.1%
Memory size	75.9 KiB

False	8420
True	1074
(Missing)	200

Common Values
Chart

Value	Count	Frequency (%)
False	8420	86.9%
True	1074	11.1%
(Missing)	200	2.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	Unnamed: 0	admission_id	patient_id	race	gender	age	weight	admission_type_code	discharge_disposition_code	admission_source_code	time_in_hospital	payer_code	medical_specialty	has_prosthesis	complete_vaccination_status	num_lab_procedures	num_procedures	num_medications	number_outpatient	number_inpatient	diag_1	diag_2	diag_3	number_diagnoses	blood_type	hemoglobin_level	blood_transfusion	max_glu_serum	A1Cresult	diuretics	insulin	change	diabetesMed	readmitted
0	0	100706.0	12224646.0	white	male	40.0	NaN	Urgent	Discharged to home	Physician Referral	3	BC	Endocrinology	False	complete	64.0	0	10.0	0	0	diseases of the digestive system	endocrine, nutritional and metabolic diseases, and immunity disorders	diseases of the circulatory system	5	A+	14.2	False	NaN	8.0	False	True	False	True	False
1	1	99518.0	1020438.0	black	male	60.0	NaN	Urgent	unknown	Clinic Referral	2	unknown	Others	False	complete	32.0	1	15.0	4	4	diseases of the circulatory system	diseases of the genitourinary system	diseases of the respiratory system	9	O-	14.1	False	NaN	NaN	False	True	False	True	False
2	2	89397.0	141934014.0	black	female	60.0	NaN	Elective	Discharged to home	Physician Referral	5	BC	Family/GeneralPractice	False	complete	57.0	2	30.0	0	0	diseases of the digestive system	diseases of the genitourinary system	diseases of the genitourinary system	9	A+	13.4	False	NaN	NaN	False	True	False	True	False
3	3	89653.0	168821964.0	white	male	50.0	NaN	Elective	Discharged to home	Physician Referral	1	MC	Radiology	False	complete	34.0	6	24.0	0	1	diseases of the circulatory system	diseases of the circulatory system	mental disorders	9	O-	15.3	False	NaN	NaN	True	True	True	True	False
4	4	83278.0	6485868.0	hispanic	male	30.0	NaN	Emergency	Discharged/transferred to SNF	Emergency Room	14	unknown	Others	False	complete	89.0	6	48.0	0	0	injury and poisoning	injury and poisoning	injury and poisoning	9	O+	14.6	True	NaN	NaN	False	True	True	True	False
5	5	83713.0	123423750.0	white	male	40.0	NaN	Emergency	Discharged/transferred to home with home health service	Emergency Room	7	unknown	Others	False	complete	3.0	0	11.0	0	1	diseases of the circulatory system	diseases of the circulatory system	diseases of the circulatory system	9	A+	15.4	False	NaN	NaN	False	True	True	True	False
6	6	101072.0	114696756.0	white	male	60.0	NaN	Emergency	Discharged to home	Emergency Room	2	MC	Others	False	complete	44.0	0	17.0	0	0	injury and poisoning	unknown	diseases of the circulatory system	9	A+	14.8	False	NaN	NaN	False	True	True	True	True
7	7	90645.0	11351394.0	white	female	60.0	NaN	Elective	Discharged/transferred to SNF	Physician Referral	3	unknown	Orthopedics	False	complete	26.0	1	32.0	0	1	diseases of the musculoskeletal system and connective tissue	endocrine, nutritional and metabolic diseases, and immunity disorders	diseases of the circulatory system	9	A+	14.2	False	NaN	NaN	False	True	False	True	False
8	8	97867.0	141851502.0	white	male	80.0	NaN	unknown	Discharged/transferred to SNF	Emergency Room	4	unknown	InternalMedicine	False	complete	41.0	0	8.0	0	0	injury and poisoning	injury and poisoning	external causes of injury	6	O+	18.0	False	85.0	NaN	False	True	False	True	False
9	9	89885.0	140092992.0	white	male	70.0	NaN	Emergency	Discharged to home	Emergency Room	3	unknown	Others	False	complete	44.0	0	13.0	0	0	diseases of the circulatory system	endocrine, nutritional and metabolic diseases, and immunity disorders	diseases of the circulatory system	9	O+	15.6	False	NaN	7.0	False	True	True	True	False

Last rows

	Unnamed: 0	admission_id	patient_id	race	gender	age	weight	admission_type_code	discharge_disposition_code	admission_source_code	time_in_hospital	payer_code	medical_specialty	has_prosthesis	complete_vaccination_status	num_lab_procedures	num_procedures	num_medications	number_outpatient	number_inpatient	diag_1	diag_2	diag_3	number_diagnoses	blood_type	hemoglobin_level	blood_transfusion	max_glu_serum	A1Cresult	diuretics	insulin	change	diabetesMed	readmitted
9684	9684	81825.0	165320082.0	white	female	70.0	NaN	Emergency	Discharged to home	Emergency Room	2	MC	InternalMedicine	False	complete	60.0	0	11.0	0	0	endocrine, nutritional and metabolic diseases, and immunity disorders	diseases of the respiratory system	diseases of the genitourinary system	9	O+	14.0	False	NaN	NaN	False	False	False	True	False
9685	9685	96103.0	84284514.0	white	male	70.0	NaN	Emergency	Discharged/transferred to SNF	Emergency Room	3	MC	Others	False	complete	53.0	0	18.0	0	1	diseases of the circulatory system	endocrine, nutritional and metabolic diseases, and immunity disorders	endocrine, nutritional and metabolic diseases, and immunity disorders	9	O+	17.4	False	NaN	8.0	False	True	True	True	False
9686	9686	96970.0	87469974.0	white	female	60.0	NaN	Elective	Discharged to home	Physician Referral	7	MC	Others	False	complete	21.0	4	11.0	0	0	neoplasms	diseases of the circulatory system	endocrine, nutritional and metabolic diseases, and immunity disorders	4	O+	13.0	False	NaN	NaN	False	True	True	True	False
9687	9687	99920.0	82030878.0	white	male	60.0	NaN	Emergency	Discharged to home	Emergency Room	2	SP	Others	False	complete	37.0	1	8.0	0	1	diseases of the digestive system	diseases of the blood and blood-forming organs	infectious and parasitic diseases	7	A-	15.1	False	NaN	NaN	False	False	False	False	False
9688	9688	88037.0	12464442.0	unknown	male	70.0	NaN	Urgent	Discharged to home	unknown	2	MC	InternalMedicine	False	complete	41.0	0	15.0	0	0	diseases of the circulatory system	endocrine, nutritional and metabolic diseases, and immunity disorders	diseases of the circulatory system	5	A+	14.0	False	NaN	NaN	False	True	True	True	False
9689	9689	91851.0	17594028.0	white	female	70.0	NaN	Emergency	unknown	Emergency Room	3	unknown	Family/GeneralPractice	False	incomplete	52.0	0	7.0	0	0	diseases of the digestive system	diseases of the circulatory system	external causes of injury	9	A+	13.0	False	NaN	NaN	False	False	False	False	False
9690	9690	84067.0	46722582.0	white	male	80.0	NaN	unknown	unknown	unknown	7	unknown	Family/GeneralPractice	False	complete	25.0	0	15.0	2	2	injury and poisoning	diseases of the circulatory system	diseases of the respiratory system	9	B+	15.2	False	85.0	NaN	False	False	False	True	False
9691	9691	85961.0	83528442.0	white	male	70.0	NaN	unknown	Discharged to home	Physician Referral	3	MC	Family/GeneralPractice	False	incomplete	45.0	0	7.0	0	0	diseases of the circulatory system	diseases of the circulatory system	diseases of the circulatory system	5	O-	14.9	False	NaN	NaN	False	False	False	True	False
9692	9692	89365.0	119906946.0	white	male	80.0	NaN	Emergency	Discharged to home	Emergency Room	1	MC	Others	False	incomplete	3.0	0	NaN	0	0	diseases of the circulatory system	diseases of the circulatory system	diseases of the circulatory system	9	O+	14.5	False	NaN	NaN	False	True	True	True	False
9693	9693	82858.0	103427046.0	hispanic	female	60.0	NaN	Emergency	Discharged to home	Physician Referral	2	unknown	InternalMedicine	False	complete	44.0	0	8.0	0	1	diseases of the circulatory system	symptoms, signs, and ill-defined conditions	external causes of injury	6	B+	13.5	False	NaN	5.0	False	False	False	False	True

Overview

Variables

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values